Functions/Procedures

A user-defined function, which is a Transact-SQL or common language runtime (CLR) routine that accepts parameters, performs an action, such as a complex calculation, and returns the result of that action as a value. The return value can either be a scalar (single) value or a table.

Stored procedures are similar to procedures in other programming languages in that they can:

Just simply click to open an object pane for Function. By using the object pane toolbar below, you can create new, edit and delete the selected function/procedure.

Create Function/Procedures

To create a new function/procedure

To create a new function/procedure with the same properties as one of the existing function/procedure has (using drag and drop method)

Apply to: current schema {same connection}
Apply to: different schema {same connection}
  different schema {different connection} (Data Transfer tool will be activated)
  • Select the function/procedure(s) for copying in the object pane.
  • Drag and drop the chosen function/procedure(s) to the target database.
  • Select one of the following options:

    • Copy
    • Cancel

To create a new function/procedure with the same properties as one of the existing function/procedure has

Edit Function/Procedure

To edit the existing function/procedure

Run Function/Procedure

To run a function/procedure in the navigation pane/object pane

To run a function/procedure in the Function/Procedure Designer

Delete Function/Procedure

To delete a function/procedure

Achieve Function/Procedure Information

To achieve a function/procedure information